/* ===============================================================================
   Cygnus Innovation Ltd.
 * Designed By Md. Ataur Rahaman
 * 
 * 
 * Descripttion: This is the ....
// ==============================================================================*/


using System;
using System.Collections.Generic;
using System.Text;

namespace nplJobsDAL
{
    class StoredProcedure
    {
        /// <summary>
        /// 
        /// </summary>
        public enum Name
        {
            // Common
            spSelectNationality,
            spSelectIndustry,
            spSelectCareerLevel,
            spSelectCompanySize,
            spSelectStatus,
            spSelectEmployeerType,
            spSelectEmployeerTypeWithJobCount,
            spGetOverseasJobDetailsCount,
            spSelectLanguage,
            spSelectLanguageProficiency,
            spSelectSalaryRange,


            //Insert stored procedures
            spInsertJobSeeker,
            spSelectGender,
            spFieldOfStudy,
            spMaritalStatus,
            spInsertEmployeer,
            spSelectEmployeeRange,
            spSelectCity,
            spDesignation,
            spSelectCountry,
            spSelectEmployeer,
            spSelectLocation,
            spSelectEmployeerContactPerson,
            spInsertJobEntry,
            spSelectApplicationProcedure,
            spInsertJobApplicationProcedure,
            spUpdateEmployeer,
            spUpdateEmployeerContactPerson,
            spDeleteEmployeerContactPerson,
            spInsertEmployeerContactPerson,
            spSelectJobSeekerByID,
            spSelectProfessionalInfoByID,
            spInsertJobSeekerEducationInfo,
            spInsertJobSeekerProfessionalInfo,
            spSelectJobSeekerbyCredentials,

            spSelectEducationalInfoByID,
            spSelectJobSeekerLanguageProficiencyByJobSeekerID,
            spInsertJobSeekerLanguageProficiency,
            spDeleteJobSeekerLanguageProficiency,
            spSelectJobSeekerByEmail,
            spSelectUserTypeByEmail,
            spSelectAppliedJobs,
            spSelectDisplayAppliedJobs,
            spSelectAppliedJobsByParam,
            spDeleteAppliedJobByID,
            spSelectDisplaySavedJobs,
            spAppliedJobsPageWise,
            spSavedJobsPageWise,
            spSelectSavedJobsByParam,
            spDeleteSavedJobByID,
            spDeleteJobSeekerSavedJobs,
            spInsertJobAlert,
            spSelectJobAlert,
            spSelectJobType,
            spSelectUserType,
            spSelectJobCategory,
            spSelectJobCategoryWithJobCount,
            spSelectGovtJobCategoryWithJobCount,
            spSelectNewspaperJobCategoryWithJobCount,
            spSelectAppliedJobsPageWise,
            spSelectJobAlertFrequency,
            spGetCitiesByJob,
            spGetOutsideCitiesByJob,
            spGetDivision,
            spGetDistrict,
            spGetCity,
            spGetWhatData,
            spGetWhereData,
            spInsertJobLocationWinthin,
            spInsertJobLocationOutside,
            spDeleteJobLocationWinthinByJob,
            spSelectJobsByJobAlert,
            spSelectJobsPageWise,
            spDeleteJobAlertByID,
            spDeleteJobAlertByJobSeeker,
            spSelectUserByID,
            spInsertJobSeekerLastUpdate,
            spDeleteJobSeekerProfessionalInfoByID,
            spDeleteJobSeekerEducationInfoByID,
            spInsertJobSeekerProfilePicture,
            spInsertJobSeekerResume,
        }
    }
}
